██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀
Sets - Execution started 09/02/2023 22:39 UTC
By Guilherme Ruiz

Table of Contents¶

  • 1  Data aquisition
    • 1.1  Fetch set lists
    • 1.2  Fetch set properties
    • 1.3  Merge data
    • 1.4  Save data
  • 3  Check changes
    • 3.1  Load previous data
    • 3.2  Generate changelog
  • 4  Data visualization
    • 4.1  Full data
    • 4.2  Set
    • 4.3  Card number
    • 4.4  Name
    • 4.5  Rarity
      • 4.5.1  By unique
      • 4.5.2  By combination
    • 4.6  Print
    • 4.7  Quantity
    • 4.8  Region
    • 4.9  Cover card
    • 4.10  Series
    • 4.11  Set type
    • 4.12  Release
      • 4.12.1  By year
      • 4.12.2  By month
      • 4.12.3  By day
      • 4.12.4  By region
      • 4.12.5  By series
      • 4.12.6  By set type
  • 5  Debug
    • 5.1  Has nan name/number
    • 5.2  Has nan rarity
    • 5.3  Has quantity as print
    • 5.4  Has nan release
    • 5.5  Has print as rarity
    • 5.6  Merge failed
  • 6  Epilogue
    • 6.1  HTML export

Data aquisition¶

Fetch set lists¶

  0%|          | 0/80 [00:00<?, ?it/s]
4121 set lists received - 76 errors

Fetch set properties¶

  0%|          | 0/96 [00:00<?, ?it/s]
1431 set properties received - 3 errors

Merge data¶

Set properties merged

Save data¶

Data saved

Check changes¶

Load previous data¶

File loaded

Generate changelog¶

Name Rarity Print Modification date Version
Card number
CL03-SC177 <NA> NaN <NA> 2022-11-07 13:43:33 Old
CL03-SC177 Aleister the Invoker (Prismatic Secret Rare,) New 2022-11-07 13:43:33 New
CL03-SC183 <NA> NaN <NA> 2022-11-07 13:43:33 Old
CL03-SC183 Invoked Mechaba (Prismatic Secret Rare,) New 2022-11-07 13:43:33 New
CL03-SC184 <NA> NaN <NA> 2022-11-07 13:43:33 Old
... ... ... ... ... ...
SDWA-EN039 Six Strike - Thunder Blast (Common,) Reprint 2016-12-31 00:14:50 New
SDWA-EN040 Six Style - Dual Wield (Common,) <NA> 2016-12-31 00:14:50 Old
SDWA-EN040 Six Style - Dual Wield (Common,) Reprint 2016-12-31 00:14:50 New
SDWA-EN041 Shadow of the Six Samurai - Shien (Ultra Rare,) <NA> 2016-12-31 00:14:50 Old
SDWA-EN041 Shadow of the Six Samurai - Shien (Ultra Rare,) New 2016-12-31 00:14:50 New

1141 rows × 5 columns

Changelog saved

Data visualization¶

Full data¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
0 Abyss Rising ABYR-EN000 Ignoble Knight of Black Laundsallyn (Super Rare,) <NA> <NA> EN 2012-11-09 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
1 Abyss Rising ABYR-EN001 Gagaga Caesar (Rare,) <NA> <NA> EN 2012-11-09 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
2 Abyss Rising ABYR-EN002 Bull Blader (Common,) <NA> <NA> EN 2012-11-09 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
3 Abyss Rising ABYR-EN003 Achacha Chanbara (Common,) <NA> <NA> EN 2012-11-09 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
4 Abyss Rising ABYR-EN004 Mogmole (Common,) <NA> <NA> EN 2012-11-09 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
156204 Jump Festa 2004 promotional cards PC3-007 Bazoo the Soul-Eater (Common, Normal Parallel Rare) <NA> <NA> JP 2003-12-20 <NA> Tournament prize card NaN https://yugipedia.com/wiki/Jump_Festa_2004_pro... 2022-11-06 04:44:51 both
156205 Jump Festa 2005 promotional cards PC5-JP007 Dark Balter the Terrible (Common, Normal Parallel Rare) <NA> <NA> JP 2004-12-18 <NA> Promotional card NaN https://yugipedia.com/wiki/Jump_Festa_2005_pro... 2022-11-06 05:15:26 both
156206 Jump Festa 2005 promotional cards PC5-JP008 Ryu Senshi (Common, Normal Parallel Rare) <NA> <NA> JP 2004-12-18 <NA> Promotional card NaN https://yugipedia.com/wiki/Jump_Festa_2005_pro... 2022-11-06 05:15:26 both
156207 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Academia_Disk 2022-12-28 20:46:20 right_only
156208 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Structure_Deck:_Mar... 2014-07-03 18:52:14 right_only

156209 rows × 14 columns

Full data available here

Set¶

Total number of sets: 1436
Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Set
"Amabie-San" Present Campaign 2 1 1 0 0 1 1 0 1 0 1 1 1
"Blue-Eyes White Dragon Rush Rare Special Red Version" GET Campaign 2 1 1 0 0 2 2 0 1 0 1 1 1
"Blue-Eyes White Dragon Secret Rare Special Blue Version" GET Campaign 1 1 1 0 0 1 1 0 1 0 1 1 1
"Blue-Eyes White Dragon" 20th Anniversary Gold Edition 0 1 1 0 0 1 1 0 1 0 1 1 1
"Blue-Eyes White Dragon" 20th Anniversary Silver Edition 0 1 1 0 0 1 1 0 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL World Duel Carnival Duel Champion Guide! promotional card 1 1 1 0 0 1 1 0 1 0 1 1 1
Yu-Gi-Oh! ZEXAL World Duel Carnival promotional cards 18 3 2 0 0 6 2 0 1 0 1 1 1
Yugi's Legendary Decks 650 112 3 0 0 5 2 0 1 0 1 1 1
Zexal Collection Tin 120 24 3 0 0 5 1 0 1 1 1 1 1
Zombie World Structure Deck 185 37 2 0 2 5 1 0 1 1 1 1 1

1436 rows × 13 columns

Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
count 1436.000000 1436.000000 1436.000000 1436.000000 1436.000000 1436.000000 1436.000000 1436.000000 1436.000000 1436.000000 1436.000000 1436.000000 1436.0
mean 107.169916 27.554318 2.502786 0.378830 0.096797 2.695682 1.454735 0.391365 0.953343 0.311281 0.994429 0.994429 1.0
std 236.007837 45.344848 2.299673 0.836417 0.446079 2.298615 0.996879 0.488226 0.210977 0.463179 0.074457 0.074457 0.0
min 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.0
25% 1.000000 1.000000 1.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.000000 1.0
50% 10.000000 5.000000 2.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.000000 1.0
75% 86.000000 41.000000 3.000000 0.000000 0.000000 5.000000 2.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.0
max 1652.000000 307.000000 17.000000 6.000000 3.000000 10.000000 9.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.0

Card number¶

Total number of card numbers: 152030
Set Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Card number
15AX-JP000 2 1 1 1 0 1 1 0 1 0 2 2 1
15AX-JPM01 1 1 1 1 0 1 1 0 1 0 1 1 1
15AX-JPM02 1 1 1 1 0 1 1 0 1 0 1 1 1
15AX-JPM03 1 1 1 1 0 1 1 0 1 0 1 1 1
15AX-JPM04 1 1 1 1 0 1 1 0 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
ZTIN-SP021 1 1 1 0 0 1 1 0 1 1 1 1 1
ZTIN-SPV01 1 1 1 0 0 1 1 0 1 1 1 1 1
ZTIN-SPV02 1 1 1 0 0 1 1 0 1 1 1 1 1
ZTIN-SPV03 1 1 1 0 0 1 1 0 1 1 1 1 1
<NA> 44 406 7 2 2 10 40 6 11 6 43 43 3

152031 rows × 13 columns

Name¶

Total number of card names: 12596
Set Card number Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Name
"A Legendary Ocean" 1 1 0 0 0 1 1 0 1 1 1 1 1
"A" Cell Breeding Device 4 9 1 1 0 7 6 1 2 3 4 4 1
"A" Cell Incubator 2 8 1 2 0 7 6 1 1 2 2 2 1
"A" Cell Recombination Device 1 8 1 0 0 8 4 1 1 1 1 1 1
"A" Cell Scatter Burst 3 9 1 1 0 7 6 1 1 3 3 3 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Zubaba Knight 12 50 5 1 1 8 23 2 2 7 12 12 1
Zubababancho Gagagacoat 1 2 1 1 0 2 2 1 1 1 1 1 1
Zure, Knight of Dark World 8 24 1 1 1 10 14 1 4 4 8 8 1
Zushin the Sleeping Giant 3 14 3 1 0 8 4 1 2 3 3 3 1
<NA> 9 159 3 3 0 9 12 4 4 4 9 9 2

12597 rows × 13 columns

Set Card number Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
count 12596.000000 12596.000000 12596.000000 12596.000000 12596.000000 12596.000000 12596.000000 12596.000000 12596.000000 12596.000000 12596.000000 12596.000000 12596.000000
mean 3.141315 12.058352 2.093919 0.689028 0.107336 6.886472 5.979994 1.091855 1.472928 1.843045 3.130041 3.130041 1.010797
std 3.514282 11.604574 1.537926 0.678188 0.336349 2.564076 5.903101 0.787795 0.936481 1.840886 3.493668 3.493668 0.103351
min 1.000000 0.000000 0.000000 0.000000 0.000000 1.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.000000
25% 1.000000 7.000000 1.000000 0.000000 0.000000 6.000000 3.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000
50% 2.000000 9.000000 2.000000 1.000000 0.000000 8.000000 4.000000 1.000000 1.000000 1.000000 2.000000 2.000000 1.000000
75% 4.000000 14.000000 3.000000 1.000000 0.000000 8.000000 7.000000 1.000000 2.000000 2.000000 4.000000 4.000000 1.000000
max 80.000000 275.000000 30.000000 4.000000 3.000000 15.000000 122.000000 12.000000 16.000000 41.000000 80.000000 80.000000 2.000000

Rarity¶

Total number of rarities: 61

By unique¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Rarity
10000 Secret Rare 2 7 1 1 0 7 2 1 1 2 2 2 1
20th Secret Rare 15 133 132 3 0 1 12 3 3 6 15 15 1
20th Secret rare 1 2 2 0 0 1 1 0 1 0 1 1 1
Collector"s Rare 5 211 61 2 0 7 5 2 1 5 5 5 1
Collector's Rare 1 90 15 2 0 6 1 0 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Ultra Rare 774 17902 3165 7 2 16 1043 32 26 278 772 772 2
Ultra Secret Rare 3 0 8 0 0 1 3 1 3 0 3 3 1
Ultra rare 51 134 77 0 0 8 69 4 8 2 51 51 1
c 1 330 55 0 0 6 2 0 1 1 1 1 1
NaN 15 385 229 3 0 4 12 3 2 3 14 14 3

62 rows × 13 columns

By combination¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Rarity
(10000 Secret Rare,) 2 7 1 1 0 7 2 1 1 2 2 2 1
(20th Secret Rare,) 8 23 22 1 0 1 7 2 3 1 8 8 1
(20th Secret rare,) 1 2 2 0 0 1 1 0 1 0 1 1 1
(Common,) 521 70067 7914 5 3 16 853 23 22 243 519 519 2
(Common, Duel Terminal Normal Parallel Rare) 1 834 139 2 0 6 1 0 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
(Ultra Rare, Ultra Parallel Rare, Ultimate Rare) 5 5 5 0 0 1 3 2 1 3 5 5 1
(Ultra Secret Rare,) 3 0 8 0 0 1 3 1 3 0 3 3 1
(Ultra rare,) 51 134 77 0 0 8 69 4 8 2 51 51 1
(c,) 1 330 55 0 0 6 2 0 1 1 1 1 1
NaN 15 385 229 3 0 4 12 3 2 3 14 14 3

138 rows × 13 columns

Print¶

Total number of prints: 17
Set Card number Name Rarity Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Print
American debut 1 3 3 1 0 1 1 0 1 1 1 1 1
European & Oceanian debut 1 6 6 1 0 1 1 0 1 0 1 1 1
European debut 12 146 146 5 0 2 10 0 2 1 12 12 1
Functional errata 1 2 2 1 0 1 1 0 1 1 1 1 1
New 248 11859 4030 52 3 11 265 19 13 135 246 246 2
New art 1 4 2 1 0 2 2 0 1 1 1 1 1
New artwork 10 74 15 5 0 7 12 3 4 4 10 10 1
New artwork (renamed) 1 3 3 1 0 1 1 0 1 0 1 1 1
North American debut 2 4 4 2 0 2 2 0 2 0 2 2 1
Oceanian debut 1 1 1 1 0 1 1 0 1 0 1 1 1
Reprint 244 14516 4367 51 3 11 260 18 12 133 242 242 2
Reprint (New Art) 2 2 1 2 0 2 2 1 1 1 2 2 1
Reprint (functional errata) 15 33 21 10 0 8 14 3 3 5 15 15 1
Reprint (new artwork) 1 1 1 1 0 1 1 0 1 1 1 1 1
Reprint (renamed) 2 76 76 6 0 1 2 1 1 0 2 2 1
TCG legal debut 1 1 1 1 0 1 1 1 1 1 1 1 1
Unknown 1 14 0 0 0 1 1 1 1 1 1 1 1
<NA> 1349 125469 11438 122 3 16 1442 42 37 315 1341 1341 3

Quantity¶

Total number of quantities: 3
Set Card number Name Rarity Print Region Release Series Set type Cover card Page URL Modification date _merge
Quantity
1 66 8760 1167 10 2 11 108 1 5 45 65 65 2
2 65 839 165 4 2 11 108 1 5 44 64 64 2
3 8 64 20 1 2 8 11 0 3 6 8 8 1
<NA> 1373 142379 12522 136 17 16 1503 45 36 317 1365 1365 3

Region¶

Total number of regions: 16
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Page URL Modification date _merge
Region
AE 34 1527 1493 12 0 2 31 2 7 19 34 34 1
AU 2 100 87 3 0 0 1 0 1 2 2 2 1
DE 455 20372 10393 54 4 3 381 12 18 219 454 454 2
EN 658 20184 10480 61 14 3 536 22 23 207 657 657 2
EU 25 543 456 9 3 0 16 2 9 6 25 25 1
FC 3 102 87 3 0 0 1 0 2 2 3 3 1
FR 448 19776 10380 56 4 3 375 14 18 219 447 447 2
IT 447 20051 10388 55 4 3 378 12 18 218 446 446 2
JA 3 185 185 8 0 0 3 2 2 3 3 3 1
JP 715 19132 11231 94 7 3 531 28 28 248 710 710 2
KR 383 15937 10755 60 4 3 333 16 15 224 378 378 2
NA 47 1526 1333 10 4 2 39 5 11 12 47 47 1
PT 204 12461 7823 46 4 3 165 8 10 120 204 204 1
SC 23 1237 1080 13 2 0 23 5 1 12 23 23 1
SP 417 19211 10285 54 4 3 356 9 17 205 416 416 2
TC 7 300 286 12 0 2 5 2 2 3 7 7 1
<NA> 2 0 0 0 0 0 0 0 0 0 2 2 1
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Page URL Modification date _merge
count 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000
mean 227.823529 8979.058824 5102.470588 32.352941 3.176471 1.764706 186.705882 8.176471 10.705882 101.117647 226.941176 226.941176 1.411765
std 254.479183 9340.556892 5032.386749 28.713980 3.521990 1.393261 205.163887 8.225230 8.716111 106.445339 253.377305 253.377305 0.507300
min 2.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 2.000000 2.000000 1.000000
25% 7.000000 300.000000 286.000000 9.000000 0.000000 0.000000 5.000000 2.000000 2.000000 3.000000 7.000000 7.000000 1.000000
50% 47.000000 1527.000000 1493.000000 13.000000 4.000000 2.000000 39.000000 5.000000 10.000000 19.000000 47.000000 47.000000 1.000000
75% 447.000000 19211.000000 10388.000000 55.000000 4.000000 3.000000 375.000000 12.000000 18.000000 218.000000 446.000000 446.000000 2.000000
max 715.000000 20372.000000 11231.000000 94.000000 14.000000 3.000000 536.000000 28.000000 28.000000 248.000000 710.000000 710.000000 2.000000

Cover card¶

Total number of cover cards: 673
Set Card number Name Rarity Print Quantity Region Release Series Set type Page URL Modification date _merge
Cover card
A-to-Z-Dragon Buster Cannon 1 352 54 4 2 2 8 4 0 1 1 1 1
Accel Synchro Stardust Dragon 1 100 50 3 2 0 2 2 0 1 1 1 1
Accesscode Talker 1 766 101 16 2 0 8 3 1 1 1 1 1
Adamancipator Risen - Dragite 1 135 46 3 2 0 3 3 0 1 1 1 1
Adreus, Keeper of Armageddon 1 84 42 4 0 0 2 2 0 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Yamiterasu the Divine Ruler 1 132 66 6 0 0 2 2 1 1 1 1 1
Yoko, the Graceful Mayakashi 2 450 60 4 2 0 8 3 0 1 2 2 1
Yubel - The Ultimate Nightmare 2 560 100 10 0 0 6 5 1 2 2 2 1
Z-Metal Tank 1 55 55 7 0 0 1 1 1 1 1 1 1
Zerrziel, Ruler of the Evil Eyed 1 90 45 3 2 0 2 2 0 1 1 1 1

673 rows × 13 columns

Series¶

Total number of series: 45
Set Card number Name Rarity Print Quantity Region Release Set type Cover card Page URL Modification date _merge
Series
+1 Bonus Pack 7 249 137 3 0 0 2 12 1 0 7 7 1
Animation Chronicle 2 200 100 7 2 0 2 4 1 2 2 2 1
Astral Pack 7 1110 184 4 4 0 6 16 1 0 7 7 1
Attribute Duelist Pack 4 429 199 6 3 0 3 9 1 4 4 4 1
Battle Pack (Rush Duel) 8 80 80 3 3 0 1 8 1 0 8 8 1
Booster (series) 4 181 176 7 2 0 1 4 1 2 4 4 1
Booster pack 1 50 50 3 0 0 1 1 1 0 1 1 1
Champion Pack 8 640 161 4 2 0 4 8 1 0 8 8 1
Classic Pack 3 570 433 9 2 0 1 3 1 2 3 3 1
Collectors Pack 8 794 374 12 3 0 3 16 1 8 8 8 1
Core Booster 88 49929 7471 41 2 0 13 296 1 80 88 88 1
Deck Build Pack 4 405 159 4 3 0 3 9 1 4 4 4 1
Deck Mod Pack 12 1447 756 8 0 0 2 23 1 12 12 12 1
Duelist Pack 21 3739 634 7 3 0 8 49 1 19 21 21 1
Entry Pack (series) 10 163 160 3 2 0 1 10 1 0 10 10 1
Expansion Pack 4 280 280 6 0 0 1 4 1 0 4 4 1
Gold Series (series) 8 2595 446 9 2 0 9 18 1 0 8 8 1
Hidden Arsenal (series) 7 2470 400 2 2 0 7 16 1 7 7 7 1
Hobby League 1 83 43 3 0 0 5 0 1 0 1 1 1
Jump Victory Carnival 1 1 1 1 0 0 1 1 1 0 1 1 1
Legend Duelist (series) 6 780 343 10 2 0 3 14 1 6 6 6 1
Legendary Collection (series) 2 57 19 1 2 0 3 4 1 0 2 2 1
Master Guide promotional cards (series) 4 8 8 1 0 0 1 4 1 0 4 4 1
Mattel Action Figure promotional cards 3 17 16 1 0 0 1 3 1 0 3 3 1
McDonald's Promotional Cards 2 35 35 4 3 0 2 2 1 0 2 2 1
Monster Figure Collection promotional cards 3 15 15 1 0 0 1 3 1 0 3 3 1
OTS Tournament Pack 2 324 54 4 0 0 6 3 1 0 2 2 1
Perfect Rulebook promotional cards 3 3 3 2 0 0 1 3 1 0 3 3 1
Pharaoh Tour promotional cards 3 20 5 2 0 0 4 3 1 0 3 3 1
Premium Pack 25 452 368 8 3 0 2 25 1 12 25 25 1
Shonen Jump promotional cards 78 85 81 2 0 0 2 44 1 0 78 78 1
Sneak Peek Participation Cards 57 302 61 4 0 0 8 69 1 0 57 57 1
Star Pack 3 900 149 4 0 0 6 6 1 3 3 3 1
Structure Deck R 3 248 122 4 2 2 2 6 1 3 3 3 1
The Valuable Book promotional cards 18 38 38 2 0 0 2 19 1 0 18 18 1
V Jump August 1999 Special Present 1 0 6 1 0 0 1 1 1 0 1 1 1
V Jump Edition (series) 4 16 16 3 0 0 1 4 1 0 4 4 1
V Jump promotional cards 78 94 98 6 0 0 1 74 1 0 78 78 1
Value Box 9 11 11 3 0 0 1 7 1 0 9 9 1
Yu-Gi-Oh! 5D's manga promotional cards 9 19 9 2 0 0 3 18 1 0 9 9 1
Yu-Gi-Oh! Day promotional cards 7 7 1 1 0 0 2 7 1 0 7 7 1
Yu-Gi-Oh! GX manga promotional cards 9 19 9 3 0 0 3 17 1 0 9 9 1
Yu-Gi-Oh! R promotional cards 4 8 4 2 0 0 2 8 1 0 4 4 1
Yu-Gi-Oh! World Championship prize cards 13 35 30 5 0 0 3 13 1 0 13 13 1
Yu-Gi-Oh! ZEXAL manga promotional cards 8 25 8 1 0 0 4 25 1 0 8 8 1

Set type¶

Total number of set types: 37
Set Card number Name Rarity Print Quantity Region Release Series Cover card Page URL Modification date _merge
Set type
Beta set 1 535 106 1 0 2 5 1 0 0 1 1 1
Binder 2 6 6 2 2 0 1 2 0 0 2 2 1
Book promotional card 4 5 5 3 0 0 2 4 1 0 4 4 1
Book promotional cards 26 52 52 4 0 0 2 27 2 0 26 26 1
Booster pack 468 114057 11784 114 16 0 14 810 23 224 468 468 1
Boss Duel Deck 1 8 8 1 0 0 1 1 0 0 1 1 1
Bundle 9 11 11 3 0 0 1 7 1 0 9 9 1
Collectible tin 53 5901 1005 11 4 0 8 66 0 35 53 53 1
Collector's Set 11 6226 1102 7 2 3 7 14 0 6 11 11 1
Core Booster 1 160 80 6 0 0 2 2 0 1 1 1 1
Deluxe Edition 4 114 19 2 0 0 6 8 0 4 4 4 1
Demo Deck 4 380 64 1 0 0 7 8 0 1 4 4 1
Duel Disk 2 16 9 2 2 0 2 4 0 0 2 2 1
Duel Disk promotional cards 5 13 12 4 0 0 2 5 0 0 5 5 1
Duel Terminal 34 1847 706 6 2 0 2 31 0 10 34 34 1
Duelist League participation cards 10 60 16 3 0 0 9 9 0 0 10 10 1
Duelist Set 5 312 154 5 0 2 2 5 0 5 5 5 1
Enhancement Pack 2 20 20 1 0 0 1 1 0 0 2 2 1
Hobby League participation cards 40 83 43 3 0 0 5 38 0 0 40 40 1
Magazine promotional card 167 191 173 9 0 0 3 127 3 7 167 167 1
Magazine promotional cards 4 4 4 2 0 0 2 2 0 0 4 4 1
Main Deck 2 44 44 2 0 0 1 2 0 1 2 2 1
Manga promotional card 33 74 32 3 0 0 4 69 4 0 33 33 1
Participation card 60 485 119 8 0 0 9 71 2 0 60 60 1
Preconstructed Deck 6 401 223 10 3 0 2 8 0 4 6 6 1
Prize card 16 46 41 5 0 0 3 16 1 0 16 16 1
Prize cards 1 68 20 1 0 0 5 1 0 0 1 1 1
Promotional card 140 315 206 22 3 0 9 141 6 21 140 140 1
Promotional cards 25 200 62 10 2 0 10 34 1 1 25 25 1
Special Edition 90 1189 289 12 5 0 10 109 0 1 90 90 1
Starter Deck 38 6777 606 10 2 3 14 59 0 26 38 38 1
Structure Deck 64 9454 1206 8 2 3 10 117 1 45 64 64 1
Tournament prize card 1 2 2 1 0 0 1 1 0 0 1 1 1
Tournament promotional card 2 5 2 2 0 0 2 2 0 0 2 2 1
Vendor Edition 6 210 210 2 0 0 1 6 0 0 6 6 1
Video game promotional card 9 79 39 5 0 0 8 15 0 0 9 9 1
Video games promotional card 23 325 73 7 2 0 9 43 0 0 23 23 1

Release¶

Total number of release dates: 1574
Set Card number Name Rarity Print Quantity Region Series Set type Cover card Page URL Modification date _merge
Release
1999-03-01 1 0 40 2 2 0 1 1 1 0 1 1 1
1999-03-18 1 0 1 1 0 0 1 0 1 0 1 1 1
1999-04-29 1 0 1 1 0 0 1 0 1 0 1 1 1
1999-05-05 1 0 1 1 0 0 1 0 1 0 1 1 1
1999-05-25 1 0 40 2 0 0 1 1 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
2023-02-25 1 190 53 5 2 0 1 1 1 0 1 1 1
2023-03-01 3 2 3 3 0 0 1 0 1 0 3 3 1
2023-03-18 1 45 25 1 3 0 1 1 1 1 1 1 1
2023-05-01 3 3 3 1 0 0 1 0 1 0 3 3 1
NaT 119 3971 1085 25 4 2 13 9 13 14 111 111 3

1575 rows × 13 columns

By year¶

Set Card number Name Rarity Print Quantity Region Series Set type Cover card Page URL _merge
Release
1999 18 0 353 28 10 2 15 8 15 1 18 15
2000 12 274 324 21 9 2 10 8 11 5 12 10
2001 12 305 307 30 4 4 12 4 11 6 12 12
2002 22 1369 1197 81 10 2 21 9 20 14 22 19
2003 51 2669 2263 125 12 0 52 12 41 29 51 38
2004 93 6502 4687 198 6 0 108 27 74 45 93 59
2005 75 7826 4043 165 27 18 127 28 64 37 75 49
2006 101 5241 3045 186 22 20 125 39 92 42 101 67
2007 126 5744 3344 283 16 18 192 53 115 54 126 94
2008 124 5979 3248 276 21 12 194 51 113 50 124 95
2009 117 5104 2973 284 8 14 172 40 111 54 117 93
2010 138 6093 3322 320 12 16 204 58 124 53 138 103
2011 144 6922 3952 326 24 18 214 55 133 53 144 105
2012 141 10271 5425 357 23 20 218 57 128 53 141 111
2013 146 8913 4469 344 22 24 222 68 129 69 146 108
2014 141 12625 5705 388 41 20 225 68 126 60 141 107
2015 136 10432 4828 358 33 12 221 69 125 57 136 103
2016 137 10356 4755 337 39 10 210 62 124 59 137 97
2017 67 8404 3324 199 27 6 140 29 64 35 67 54
2018 46 5413 2129 141 26 0 103 20 41 28 46 41
2019 50 6264 2670 162 29 0 101 17 45 25 50 43
2020 38 6435 2143 151 34 0 85 18 36 27 38 36
2021 65 6812 2733 241 46 6 91 38 53 36 65 49
2022 73 8953 3698 250 66 3 96 43 61 42 73 56
2023 16 843 387 43 10 0 16 8 10 5 16 10

By month¶

By day¶

By region¶

Set Card number Name Rarity Print Quantity Series Set type Cover card Page URL Modification date _merge
Region Release
AE 2001-06-04 1 0 2 1 0 0 0 0 0 1 1 1
2002-08-08 2 100 87 3 0 0 0 1 2 2 2 1
2002-10-24 1 144 144 5 0 0 1 1 1 1 1 1
2003-04-17 1 3 3 1 0 0 0 1 0 1 1 1
2003-06-26 1 105 105 5 0 0 1 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
TC 2014-01-29 1 40 40 4 0 2 0 1 1 1 1 1
2014-05-01 1 20 20 4 0 0 1 1 0 1 1 1
2015-03-01 2 40 26 1 0 0 0 0 0 2 2 1
2015-08-29 1 100 100 6 0 0 1 1 1 1 1 1
2015-12-05 1 100 100 6 0 0 1 1 1 1 1 1

3174 rows × 12 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Region
AE 0 0 1 3 4 3 3 5 2 1 4 1 1 1 1 1 1 0 0 0 0 0 0 0 0
AU 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DE 0 0 0 0 8 21 22 17 31 27 23 28 31 30 28 30 27 28 20 15 13 10 8 7 1
EN 0 0 2 2 3 16 29 48 50 45 33 45 47 49 42 43 34 35 20 15 13 10 12 11 2
EU 0 0 0 2 2 4 0 0 0 2 0 2 0 0 0 2 2 1 0 0 0 0 0 0 0
FC 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FR 0 0 0 0 5 20 22 17 31 27 23 27 28 30 29 28 27 28 19 15 13 10 8 7 1
IT 0 0 0 0 5 20 21 17 31 27 23 27 29 30 28 28 27 28 20 15 13 10 8 7 1
JA 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0
JP 18 12 9 11 11 20 24 26 32 40 40 49 46 44 49 43 43 52 14 16 20 14 25 26 11
KR 0 0 0 0 2 8 7 13 20 24 21 21 30 29 29 23 22 21 17 10 12 10 23 26 1
NA 0 0 0 5 16 6 0 2 2 1 2 1 1 0 0 2 3 0 2 0 0 0 0 0 0
PT 0 0 0 0 0 10 6 0 0 0 0 0 0 1 24 24 25 26 18 14 13 9 8 7 1
SC 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 7 10 2
SP 0 0 0 0 4 20 20 10 24 22 21 27 27 30 28 28 27 28 19 14 13 10 9 7 1
TC 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 4 0 0 0 0 0 0 0 0

By series¶

Set Card number Name Rarity Print Quantity Region Set type Cover card Page URL Modification date _merge
Series Release
+1 Bonus Pack 2020-10-31 1 19 19 3 0 0 1 1 0 1 1 1
2021-02-04 1 20 20 3 0 0 1 1 0 1 1 1
2021-04-17 1 19 19 3 0 0 1 1 0 1 1 1
2021-07-17 1 19 19 3 0 0 1 1 0 1 1 1
2021-07-21 1 19 19 3 0 0 1 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL manga promotional cards 2015-09-01 1 1 1 1 0 0 1 1 0 1 1 1
2015-10-03 1 1 1 1 0 0 1 1 0 1 1 1
2015-12-18 1 1 1 1 0 0 1 1 0 1 1 1
2016-03-01 1 1 1 1 0 0 1 1 0 1 1 1
2016-09-06 1 1 1 1 0 0 1 1 0 1 1 1

889 rows × 12 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Series
+1 Bonus Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 6 4 1
Animation Chronicle 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0
Astral Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 8 3 0 0 0 0 0 0 0 0
Attribute Duelist Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3 4 0
Battle Pack (Rush Duel) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4 1
Booster (series) 0 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Booster pack 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Champion Pack 0 0 0 0 0 0 0 1 3 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Classic Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1
Collectors Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 2 2 2 2 2 2 0 0 0
Core Booster 6 0 2 6 11 22 17 17 25 13 14 15 14 16 18 16 17 16 12 10 8 6 8 8 1
Deck Build Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 6 1
Deck Mod Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 9 8 2
Duelist Pack 0 0 0 0 0 0 2 9 9 10 4 6 7 3 3 1 3 5 1 0 0 0 0 0 0
Entry Pack (series) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 4 1
Expansion Pack 0 0 0 0 0 0 0 0 0 3 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
Gold Series (series) 0 0 0 0 0 0 0 0 0 2 0 2 3 2 0 5 2 2 0 0 0 0 0 0 0
Hidden Arsenal (series) 0 0 0 0 0 0 0 0 0 0 1 3 6 3 3 0 0 0 0 0 0 0 0 0 0
Jump Victory Carnival 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
Legend Duelist (series) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4 4 1 1 1 0
Legendary Collection (series) 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0
Master Guide promotional cards (series) 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0
Mattel Action Figure promotional cards 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
McDonald's Promotional Cards 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monster Figure Collection promotional cards 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0
OTS Tournament Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0
Perfect Rulebook promotional cards 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0
Pharaoh Tour promotional cards 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Premium Pack 0 3 1 0 0 3 1 1 1 2 2 2 1 2 2 2 2 0 0 0 0 0 0 0 0
Shonen Jump promotional cards 0 0 0 0 0 0 2 3 4 3 2 7 2 4 4 6 4 6 1 0 0 0 0 0 0
Sneak Peek Participation Cards 0 0 0 0 0 0 4 4 9 8 3 4 4 5 4 4 4 5 5 3 2 1 0 0 0
Star Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 1 2 0 0 0 0 0 0 0 0
Structure Deck R 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 1 0 0 0 0 0 0
The Valuable Book promotional cards 1 1 0 2 1 1 1 1 1 1 1 1 1 1 2 1 1 0 1 0 0 0 0 0 0
V Jump August 1999 Special Present 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V Jump Edition (series) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 0 0 0 0
V Jump promotional cards 0 0 0 0 0 0 0 0 0 5 7 7 7 8 10 8 11 13 2 0 0 0 0 0 0
Value Box 0 0 0 0 0 0 0 0 0 0 0 0 1 2 4 1 1 0 0 0 0 0 0 0 0
Yu-Gi-Oh! 5D's manga promotional cards 0 0 0 0 0 0 0 0 0 0 0 2 2 3 4 3 3 1 0 0 0 0 0 0 0
Yu-Gi-Oh! Day promotional cards 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 2 1 0 0 0 0 0 0
Yu-Gi-Oh! GX manga promotional cards 0 0 0 0 0 0 0 1 2 3 3 4 3 2 0 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! R promotional cards 0 0 0 0 0 0 1 1 1 1 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! World Championship prize cards 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
Yu-Gi-Oh! ZEXAL manga promotional cards 0 0 0 0 0 0 0 0 0 0 0 0 0 4 6 6 7 2 0 0 0 0 0 0 0

By set type¶

Set Card number Name Rarity Print Quantity Region Series Cover card Page URL Modification date _merge
Set type Release
Beta set 2017-10-04 1 535 106 1 0 2 5 0 0 1 1 1
Binder 2012-09-21 1 3 3 1 2 0 1 0 0 1 1 1
2015-04-29 1 3 3 1 0 0 1 0 0 1 1 1
Book promotional card 2004-12-18 1 2 2 1 0 0 1 0 0 1 1 1
2014-04-04 1 1 1 1 0 0 1 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Video games promotional card 2011-04-28 1 7 7 1 0 0 1 0 0 1 1 1
2011-05-10 1 3 3 1 0 0 1 0 0 1 1 1
2013-12-05 1 3 3 1 0 0 1 0 0 1 1 1
2014-06-26 1 15 3 2 0 0 5 0 0 1 1 1
2016-07-16 1 1 1 1 0 0 1 0 0 1 1 1

1866 rows × 12 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Set type
Beta set 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0
Binder 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0
Book promotional card 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0
Book promotional cards 1 2 0 2 1 2 1 1 1 2 1 1 2 1 3 2 2 1 1 0 0 0 0 0 0
Booster pack 6 7 4 10 15 40 34 36 44 43 35 48 53 54 59 65 56 52 38 28 31 31 52 53 9
Boss Duel Deck 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
Bundle 0 0 0 0 0 0 0 0 0 0 0 0 1 2 4 1 1 0 0 0 0 0 0 0 0
Collectible tin 0 0 0 1 2 2 2 3 3 7 10 6 5 4 7 2 2 2 2 1 2 1 1 1 0
Collector's Set 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 3 2 1 4 0
Core Booster 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Deluxe Edition 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 6 0 0 0 0 0 0 0 0 0
Demo Deck 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 2 2 0 3 0 0 0 0 0
Duel Disk 0 0 0 0 0 0 0 1 1 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0
Duel Disk promotional cards 0 0 0 0 0 0 0 1 1 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Duel Terminal 0 0 0 0 0 0 0 0 0 6 4 7 6 9 2 0 0 0 0 0 0 0 0 0 0
Duelist League participation cards 0 0 0 0 4 4 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Duelist Set 0 0 0 0 0 0 0 0 0 0 0 0 0 3 5 1 0 0 0 0 0 0 0 0 0
Enhancement Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0
Hobby League participation cards 0 0 0 0 0 2 1 13 12 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Magazine promotional card 1 0 0 0 0 0 3 3 4 10 10 17 10 13 14 14 15 20 3 0 0 0 0 0 0
Magazine promotional cards 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Main Deck 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0
Manga promotional card 0 0 0 1 0 0 1 4 3 4 4 9 5 9 10 9 10 3 0 0 0 0 0 0 0
Participation card 1 0 0 0 0 0 4 4 9 8 4 5 4 5 4 4 4 5 5 3 2 1 0 0 0
Preconstructed Deck 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 0 0 4 0
Prize card 0 0 2 0 0 1 1 1 1 1 1 1 2 1 1 1 1 1 0 0 0 0 0 0 0
Prize cards 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
Promotional card 2 0 2 1 0 1 1 8 8 5 7 14 19 8 5 5 7 17 5 3 6 2 9 11 7
Promotional cards 2 0 1 1 5 7 2 1 0 0 1 4 3 1 3 2 1 0 0 0 1 0 0 0 0
Special Edition 0 0 0 0 2 3 3 7 12 11 13 8 8 12 2 3 7 8 7 4 2 1 0 0 0
Starter Deck 1 1 0 4 13 18 2 0 3 2 5 4 3 4 8 5 7 4 0 0 0 0 2 0 0
Structure Deck 0 0 2 1 3 0 8 10 8 6 7 6 9 9 8 11 13 17 4 0 0 0 0 0 0
Tournament prize card 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tournament promotional card 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Vendor Edition 0 0 0 0 0 1 2 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Video game promotional card 1 2 0 0 0 0 0 0 5 0 3 4 2 0 0 0 0 0 0 0 0 0 0 0 0
Video games promotional card 0 0 0 1 3 8 7 4 8 4 3 0 4 0 1 1 0 1 0 0 0 0 0 0 0

Debug¶

This section is used for debugging the extraction of data from MediaWiki query responses

Has nan name/number¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
8403 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> IT 2016-10-06 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
8448 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> IT 2016-10-06 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
8493 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> IT 2016-10-06 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
8541 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> PT 2016-10-07 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
8586 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> PT 2016-10-07 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
145226 EX Starter Box <NA> De-Spell (Common,) Reprint 2 JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) https://yugipedia.com/wiki/EX_Starter_Box 2022-05-01 06:51:59 both
145227 EX Starter Box <NA> Castle Walls (Common,) Reprint 1 JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) https://yugipedia.com/wiki/EX_Starter_Box 2022-05-01 06:51:59 both
145228 EX Starter Box <NA> Ultimate Offering (Common,) Reprint 1 JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) https://yugipedia.com/wiki/EX_Starter_Box 2022-05-01 06:51:59 both
156207 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Academia_Disk 2022-12-28 20:46:20 right_only
156208 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Structure_Deck:_Mar... 2014-07-03 18:52:14 right_only

718 rows × 14 columns

Has nan rarity¶

array(['Dark Revelation Volume 2', 'Dark Beginning 2',
       'Advanced Tournament Pack 2016 Vol.1',
       'Advanced Tournament Pack 2013 Vol.4',
       'The Valuable Book character cards', 'Dark Beginning 1',
       'V Jump April 2013 Tokens', 'Advanced Event Pack 2013 Vol.2',
       'Dark Revelation Volume 1', 'Advanced Tournament Pack 2013 Vol.3',
       'Advanced Event Pack 2014 Vol.1', 'Classic Pack 03',
       'Deck Build Pack: Wild Survivors', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has nan release¶

array(['Invasion: Vengeance Sneak Peek Participation Card',
       'Raging Battle Sneak Peek Participation Card',
       'Structure Deck: Machine Re-Volt Special Edition',
       'Yu-Gi-Oh! Power of Chaos: Kaiba the Revenge promotional cards',
       'Astral Pack Two',
       'Dimension of Chaos Sneak Peek Participation Card',
       'Millennium Pack', 'Sneak Peek Participation Cards', 'Spell Ruler',
       "Yu-Gi-Oh! 5D's World Championship 2011: Over the Nexus promotional cards",
       'Hobby League 7 participation card D',
       'Shonen Jump Vol. 10, Issue 1 promotional card',
       "Yu-Gi-Oh! 5D's Volume 1 promotional card", 'Invader of Darkness',
       'Legacy of the Valiant Sneak Peek Participation Card',
       'Shadow Specters Sneak Peek Participation Card',
       'Shonen Jump Vol. 4, Issue 11 promotional card',
       'The Valuable Book promotional cards',
       'Shonen Jump Vol. 7, Issue 6 promotional card',
       'Hobby League 6 participation card E', 'Structure Deck: Marik',
       'Secrets of Eternity Sneak Peek Participation Card',
       'National Championship 2013', 'Tournament Pack 2009 Vol.3',
       'Yu-Gi-Oh! Worldwide Edition: Stairway to the Destined Duel promotional cards',
       'Yu-Gi-Oh! R promotional cards',
       "Structure Deck: Dinosaur's Rage Special Edition",
       'Ancient Prophecy Sneak Peek Participation Card',
       'Astral Pack One', 'The Lost Millennium: Special Edition',
       "Yu-Gi-Oh! 5D's Wheelie Breakers promotional cards", 'Duel Disk',
       'Shonen Jump Vol. 10, Issue 3 promotional card',
       'Yu-Gi-Oh! GX manga promotional cards',
       'Shonen Jump Vol. 3, Issue 6 promotional card',
       'Tournament Pack 2008 Vol.1',
       'Yu-Gi-Oh! GX Volume 4 promotional card', 'Premium Pack',
       'Shonen Jump Vol. 4, Issue 12 promotional card',
       'The Valuable Book character cards',
       'Crossed Souls Sneak Peek Participation Card',
       'Duelist League Demo 2010', 'Gold Series',
       'Hobby League 6 participation card F',
       'Shonen Jump Vol. 9, Issue 4 promotional card', 'Premium Pack 2',
       'Yu-Gi-Oh! Championship Series Prize Cards',
       'Shonen Jump Vol. 6, Issue 5 promotional card',
       'Hobby League 6 participation card A',
       'Shonen Jump December 2010 subscription bonus',
       'The New Challengers Sneak Peek Participation Card',
       'Tournament Pack 2009 Vol.4',
       "Yu-Gi-Oh! 5D's manga promotional cards", 'Curse of Anubis',
       'Shonen Jump Scholastic Edition Vol. 9, Issue 1 promotional card',
       'Academy Duel Disk', 'Ancient Sanctuary',
       'Shadow of Infinity: Special Edition',
       'Shonen Jump Vol. 10, Issue 4 promotional card',
       'Hobby League participation cards',
       'Shonen Jump Vol. 3, Issue 9 promotional card',
       'Shonen Jump Vol. 5, Issue 1 promotional card',
       'Tournament Pack 2008 Vol.2',
       'Shonen Jump Vol. 7, Issue 9 promotional card',
       'Shonen Jump Vol. 9, Issue 6 promotional card',
       'Hobby League 7 participation card A',
       'Shonen Jump May 2008 subscription bonus',
       'Shonen Jump Vol. 7, Issue 3 promotional card',
       'Hobby League 6 participation card B',
       'Shonen Jump June/July 2011 subscription bonus',
       'Banzai! promotional cards',
       'Shonen Jump August 2008 subscription bonus',
       "Structure Deck: Dinosaur's Rage Special Set",
       'Shonen Jump Vol. 3, Issue 11 promotional card',
       'Shonen Jump Vol. 5, Issue 6 promotional card',
       'Shonen Jump Vol. 9, Issue 8 promotional card',
       'Hobby League 7 participation card B',
       'Shonen Jump Vol. 6, Issue 9 promotional card', 'Magic Ruler',
       'Hobby League 6 participation card C',
       'Shonen Jump May 2006 subscription bonus',
       'National Championship 2011',
       'Shonen Jump May 2010 subscription bonus',
       'Shonen Jump Vol. 6, Issue 1 promotional card',
       'Shonen Jump Vol. 4, Issue 2 promotional card', 'Ultimate Edition',
       'Shonen Jump Vol. 7, Issue 11 promotional card',
       'Hobby League 7 participation card C',
       'Shonen Jump Vol. 9, Issue 10 promotional card',
       'The Sanctuary in the Sky', 'Hobby League 6 participation card D',
       'Shonen Jump Championship Series Prize Cards',
       'Shonen Jump Vol. 9, Issue 1 promotional card',
       'National Championship 2012',
       'Yu-Gi-Oh! The Official Magazine promotional cards',
       '2013 Collectible Tins', '20th Anniversary Duel Set',
       'Booster Pack Tin Series Promos',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Collectible Tins 2005', 'Collectible Tins 2006',
       'Collectible Tins 2007', 'Collectible Tins 2008',
       'Collectible Tins 2008 Wave 2', 'Collectible Tins 2009',
       'Collectible Tins 2010', 'Collectible Tins 2011',
       'Collectible Tins 2012',
       'Continuous Token Gifts Promotional Cards', 'Demo Pack',
       'Duelist League 18 participation cards',
       'Duelist League Series 1 participation cards',
       'Duelist League Series 2 participation cards',
       'Duelist Pack: Yugi', 'Exclusive Pack', 'Ghosts From the Past',
       'Judge promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Merge failed¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
156207 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Academia_Disk 2022-12-28 20:46:20 right_only
156208 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Structure_Deck:_Mar... 2014-07-03 18:52:14 right_only 
8
array(['Abyss Rising', 'Advent of Union',
       'Battle Pack 2: War of the Giants', ...,
       'Jump Festa 2005 promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)
Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge

Epilogue¶

Execution completed 09/02/2023 22:48 UTC

HTML export¶

Notebook saved to disk